<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="MetaDataCollections" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="MetaDataCollections">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="CollectionName" type="xs:string" minOccurs="0" />
                <xs:element name="NumberOfRestrictions" type="xs:int" minOccurs="0" />
                <xs:element name="NumberOfIdentifierParts" type="xs:int" minOccurs="0" />
                <xs:element name="PopulationMechanism" type="xs:string" minOccurs="0" />
                <xs:element name="PopulationString" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <MetaDataCollections>
    <CollectionName>MetaDataCollections</CollectionName>
    <NumberOfRestrictions>0</NumberOfRestrictions>
    <NumberOfIdentifierParts>0</NumberOfIdentifierParts>
    <PopulationMechanism>DataTable</PopulationMechanism>
    <PopulationString>MetaDataCollections</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>DataSourceInformation</CollectionName>
    <NumberOfRestrictions>0</NumberOfRestrictions>
    <NumberOfIdentifierParts>0</NumberOfIdentifierParts>
    <PopulationMechanism>DataTable</PopulationMechanism>
    <PopulationString>DataSourceInformation</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>DataTypes</CollectionName>
    <NumberOfRestrictions>0</NumberOfRestrictions>
    <NumberOfIdentifierParts>0</NumberOfIdentifierParts>
    <PopulationMechanism>DataTable</PopulationMechanism>
    <PopulationString>DataTypes</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Restrictions</CollectionName>
    <NumberOfRestrictions>0</NumberOfRestrictions>
    <NumberOfIdentifierParts>0</NumberOfIdentifierParts>
    <PopulationMechanism>DataTable</PopulationMechanism>
    <PopulationString>Restrictions</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>ReservedWords</CollectionName>
    <NumberOfRestrictions>0</NumberOfRestrictions>
    <NumberOfIdentifierParts>0</NumberOfIdentifierParts>
    <PopulationMechanism>DataTable</PopulationMechanism>
    <PopulationString>ReservedWords</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Users</CollectionName>
    <NumberOfRestrictions>1</NumberOfRestrictions>
    <NumberOfIdentifierParts>1</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT USERNAME AS Name, USER_ID AS ID, CREATED AS CreateDate FROM ALL_USERS WHERE (USERNAME=:NAME or :NAME is null) ORDER BY USERNAME</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Tables</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, TABLE_NAME, DECODE(OWNER, 'SYS', 'System', 'SYSTEM', 'System', 'SYSMAN', 'System','CTXSYS', 'System','MDSYS', 'System','OLAPSYS', 'System', 'ORDSYS', 'System','OUTLN', 'System', 'WKSYS', 'System','WMSYS', 'System','XDB', 'System','ORDPLUGINS', 'System','User') AS Type FROM ALL_TABLES WHERE (OWNER=:OWNER or :OWNER IS NULL) AND (TABLE_NAME = :TABLENAME or :TABLENAME is NULL) ORDER BY OWNER, TABLE_NAME</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Columns</CollectionName>
    <NumberOfRestrictions>3</NumberOfRestrictions>
    <NumberOfIdentifierParts>3</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, TABLE_NAME, COLUMN_NAME, COLUMN_ID AS ID, DATA_TYPE AS DataType, DATA_LENGTH AS Length, DATA_PRECISION AS Precision, DATA_SCALE AS Scale, NULLABLE AS Nullable, CHAR_USED, CHAR_LENGTH AS LengthInChars FROM ALL_TAB_COLUMNS WHERE (OWNER = :OWNER or :OWNER is null) AND (TABLE_NAME = :TABLENAME OR :TABLENAME is null) AND (COLUMN_NAME = :COLUMNNAME OR :COLUMNNAME is null) ORDER BY OWNER, TABLE_NAME, ID</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Views</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT * FROM ALL_VIEWS WHERE (OWNER = :OWNER OR :OWNER is null) AND (VIEW_NAME = :VIEWNAME OR :VIEWNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Synonyms</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT * FROM ALL_SYNONYMS WHERE (OWNER = :OWNER OR :OWNER is null) AND (SYNONYM_NAME = :SYNONYMNAME OR :SYNONYMNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Sequences</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT * FROM ALL_SEQUENCES WHERE (SEQUENCE_OWNER = :OWNER OR :OWNER is null) AND (SEQUENCE_NAME = :SEQUENCENAME OR :SEQUENCENAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Functions</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY FROM ALL_OBJECTS WHERE (OWNER = :OWNER  OR :OWNER is null) AND (OBJECT_NAME = :OBJECTNAME OR :OBJECTNAME is null) AND OBJECT_TYPE = 'FUNCTION'</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Procedures</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY FROM ALL_OBJECTS WHERE (OWNER= :OWNER OR :OWNER is null) and (OBJECT_NAME = :OBJECTNAME OR :OBJECTNAME is null) AND OBJECT_TYPE = 'PROCEDURE'</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Packages</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID,  LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY, CREATED FROM ALL_OBJECTS WHERE (OWNER= :OWNER OR :OWNER is null) and (OBJECT_NAME = :PACKAGENAME OR :PACKAGENAME is null) AND OBJECT_TYPE = 'PACKAGE'</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>PackageBodies</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, OBJECT_NAME, SUBOBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY, GENERATED, SECONDARY, CREATED FROM ALL_OBJECTS WHERE (OWNER= :OWNER OR :OWNER is null) and (OBJECT_NAME = :PKGBODYNAME OR :PKGBODYNAME is null) AND OBJECT_TYPE = 'PACKAGE BODY'</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>IndexColumns</CollectionName>
    <NumberOfRestrictions>5</NumberOfRestrictions>
    <NumberOfIdentifierParts>3</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT INDEX_OWNER, INDEX_NAME, TABLE_OWNER, TABLE_NAME, COLUMN_NAME, COLUMN_POSITION, COLUMN_LENGTH, CHAR_LENGTH, DESCEND FROM ALL_IND_COLUMNS WHERE (INDEX_OWNER = :OWNER OR :OWNER is null) AND (INDEX_NAME = :INDEXNAME OR :INDEXNAME is null) AND (TABLE_OWNER = :TABLEOWNER OR :TABLEOWNER is null) AND (TABLE_NAME = :TABLENAME OR :TABLENAME is null) AND (COLUMN_NAME = :COLUMNNAME OR :COLUMNNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Indexes</CollectionName>
    <NumberOfRestrictions>4</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT * FROM ALL_INDEXES WHERE (OWNER = :OWNER OR :OWNER is null) AND (INDEX_NAME = :INDEXNAME OR :INDEXNAME is null) AND (TABLE_OWNER = :TABLEOWNER OR :TABLEOWNER is null) AND (TABLE_NAME = :TABLENAME OR :TABLENAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>ProcedureParameters</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT * FROM ALL_ARGUMENTS WHERE DATA_LEVEL = 0 AND (OWNER = :OWNER  OR :OWNER is null) AND (OBJECT_NAME = :OBJECTNAME  OR :OBJECTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>Arguments</CollectionName>
    <NumberOfRestrictions>4</NumberOfRestrictions>
    <NumberOfIdentifierParts>4</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, PACKAGE_NAME, OBJECT_NAME, ARGUMENT_NAME, POSITION, SEQUENCE, DEFAULT_VALUE, DEFAULT_LENGTH, IN_OUT, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, DATA_TYPE, CHAR_USED FROM ALL_ARGUMENTS WHERE (OWNER= :OWNER OR :OWNER is null) AND (PACKAGE_NAME = :PACKAGENAME OR :PACKAGENAME is null) AND (OBJECT_NAME = :OBJECTNAME OR :OBJECTNAME is null) AND (ARGUMENT_NAME = :ARGUMENTNAME OR :ARGUMENTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>UniqueKeys</CollectionName>
    <NumberOfRestrictions>3</NumberOfRestrictions>
    <NumberOfIdentifierParts>3</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, CONSTRAINT_NAME, TABLE_NAME, SEARCH_CONDITION, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'U' AND (OWNER = :OWNER OR :OWNER is null) AND (TABLE_NAME = :TABLENAME OR :TABLENAME is null) AND (CONSTRAINT_NAME = :CONSTRAINTNAME OR :CONSTRAINTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>PrimaryKeys</CollectionName>
    <NumberOfRestrictions>3</NumberOfRestrictions>
    <NumberOfIdentifierParts>3</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, CONSTRAINT_NAME, TABLE_NAME, SEARCH_CONDITION, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME FROM ALL_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'P' AND (OWNER = :OWNER OR :OWNER is null) AND (TABLE_NAME = :TABLENAME OR :TABLENAME is null) AND (CONSTRAINT_NAME = :CONSTRAINTNAME OR :CONSTRAINTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>ForeignKeys</CollectionName>
    <NumberOfRestrictions>3</NumberOfRestrictions>
    <NumberOfIdentifierParts>3</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT PKCON.CONSTRAINT_NAME AS PRIMARY_KEY_CONSTRAINT_NAME, PKCON.OWNER AS PRIMARY_KEY_OWNER, PKCON.TABLE_NAME AS PRIMARY_KEY_TABLE_NAME,FKCON.OWNER AS FOREIGN_KEY_OWNER, FKCON.CONSTRAINT_NAME AS FOREIGN_KEY_CONSTRAINT_NAME,FKCON.TABLE_NAME AS FOREIGN_KEY_TABLE_NAME, FKCON.SEARCH_CONDITION, FKCON.R_OWNER, FKCON.R_CONSTRAINT_NAME, FKCON.DELETE_RULE, FKCON.STATUS, FKCON.VALIDATED, FKCON.GENERATED, FKCON.RELY, FKCON.LAST_CHANGE, FKCON.INDEX_OWNER, FKCON.INDEX_NAME FROM ALL_CONSTRAINTS FKCON, ALL_CONSTRAINTS PKCON WHERE PKCON.OWNER = FKCON.R_OWNER AND PKCON.CONSTRAINT_NAME = FKCON.R_CONSTRAINT_NAME AND FKCON.CONSTRAINT_TYPE = 'R' and (FKCON.OWNER= :OWNER OR :OWNER is null) AND (FKCON.TABLE_NAME = :TABLENAME OR :TABLENAME is null) AND (FKCON.CONSTRAINT_NAME = :CONSTRAINTNAME OR :CONSTRAINTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>ForeignKeyColumns</CollectionName>
    <NumberOfRestrictions>3</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT FKCOLS.OWNER, FKCOLS.CONSTRAINT_NAME, FKCOLS.TABLE_NAME, FKCOLS.COLUMN_NAME, FKCOLS.POSITION FROM ALL_CONS_COLUMNS FKCOLS, ALL_CONSTRAINTS FKCON where FKCOLS.OWNER = FKCON.OWNER and FKCOLS.TABLE_NAME = FKCON.TABLE_NAME and FKCOLS.CONSTRAINT_NAME = FKCON.CONSTRAINT_NAME AND FKCOLS.OWNER= FKCON.OWNER and FKCOLS.TABLE_NAME= FKCON.TABLE_NAME and FKCON.CONSTRAINT_TYPE = 'R' AND (FKCOLS.OWNER=:OWNER OR :OWNER is null) and (FKCOLS.TABLE_NAME = :TABLENAME OR :TABLENAME is null) and (FKCOLS.CONSTRAINT_NAME = :CONSTRAINTNAME OR :CONSTRAINTNAME is null) ORDER BY FKCOLS.OWNER, FKCOLS.CONSTRAINT_NAME, FKCOLS.TABLE_NAME</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>JavaClasses</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, NAME, MAJOR, MINOR, KIND, ACCESSIBILITY, IS_INNER, IS_ABSTRACT, IS_FINAL, IS_DEBUG, SOURCE, SUPER, OUTER FROM ALL_JAVA_CLASSES WHERE (OWNER= :OWNER OR :OWNER is null) and (NAME = :OBJECTNAME OR :OBJECTNAME is null)</PopulationString>
  </MetaDataCollections>
  <MetaDataCollections>
    <CollectionName>XMLSchemas</CollectionName>
    <NumberOfRestrictions>2</NumberOfRestrictions>
    <NumberOfIdentifierParts>2</NumberOfIdentifierParts>
    <PopulationMechanism>OracleCommand</PopulationMechanism>
    <PopulationString>SELECT OWNER, SCHEMA_URL, LOCAL, SYS.XMLTYPE.GETCLOBVAL(SCHEMA) as SCHEMA, INT_OBJNAME, QUAL_SCHEMA_URL, HIER_TYPE FROM ALL_XML_SCHEMAS WHERE (OWNER= :OWNER OR :OWNER is null) and (SCHEMA_URL = :SCHEMAURL OR :SCHEMAURL is null)</PopulationString>
  </MetaDataCollections>
</NewDataSet>